Tabela StockItemQuantity

Definicja tabeli StockItemQuantity

Name

StockItemQuantity

Code

StockItemQuantity

Comment

 


Lista kolumn tabeli StockItemQuantity

Name

Code

StockItemQuantityID

StockItemQuantityID

StockItemID

StockItemID

StockDocumentID

StockDocumentID

SeriesDataID

SeriesDataID

PackageID

PackageID

StockEntryDocumentItemID

StockEntryDocumentItemID

BloodDetailsID

BloodDetailsID

CostAccountID

CostAccountID

PersonID

PersonID

StockItemQuantityIndexID

StockItemQuantityIndexID

Quantity

Quantity

Price

Price

Value

Value

StockIndex

StockIndex

OwnerID

OwnerID

PatientID

PatientID

Comments

Comments

StockItemQuantityDetailsID

StockItemQuantityDetailsID


Kolumna StockItemQuantityID tabeli StockItemQuantity

Definicja kolumny StockItemQuantityID tabeli StockItemQuantity

Name

StockItemQuantityID

Code

StockItemQuantityID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockItemID tabeli StockItemQuantity

Definicja kolumny StockItemID tabeli StockItemQuantity

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna StockDocumentID tabeli StockItemQuantity

Definicja kolumny StockDocumentID tabeli StockItemQuantity

Name

StockDocumentID

Code

StockDocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SeriesDataID tabeli StockItemQuantity

Definicja kolumny SeriesDataID tabeli StockItemQuantity

Name

SeriesDataID

Code

SeriesDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PackageID tabeli StockItemQuantity

Definicja kolumny PackageID tabeli StockItemQuantity

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockEntryDocumentItemID tabeli StockItemQuantity

Definicja kolumny StockEntryDocumentItemID tabeli StockItemQuantity

Name

StockEntryDocumentItemID

Code

StockEntryDocumentItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BloodDetailsID tabeli StockItemQuantity

Definicja kolumny BloodDetailsID tabeli StockItemQuantity

Name

BloodDetailsID

Code

BloodDetailsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli StockItemQuantity

Definicja kolumny CostAccountID tabeli StockItemQuantity

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli StockItemQuantity

Definicja kolumny PersonID tabeli StockItemQuantity

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StockItemQuantityIndexID tabeli StockItemQuantity

Definicja kolumny StockItemQuantityIndexID tabeli StockItemQuantity

Name

StockItemQuantityIndexID

Code

StockItemQuantityIndexID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie pozycji dokumentu z partia, której ten
dokument dotyczy.


Kolumna Quantity tabeli StockItemQuantity

Definicja kolumny Quantity tabeli StockItemQuantity

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc


Kolumna Price tabeli StockItemQuantity

Definicja kolumny Price tabeli StockItemQuantity

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Value tabeli StockItemQuantity

Definicja kolumny Value tabeli StockItemQuantity

Name

Value

Code

Value

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna StockIndex tabeli StockItemQuantity

Definicja kolumny StockIndex tabeli StockItemQuantity

Name

StockIndex

Code

StockIndex

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli StockItemQuantity

Definicja kolumny OwnerID tabeli StockItemQuantity

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole sluzy do przechowywania informacji, iz danych stan magazynowy
(StockItemQuantityIndex) lub jego zmiana (StockItemQuantity) dotyczy leków
danego pacjenta. Leki przyniósl sam pacjent do szpitala.


Kolumna PatientID tabeli StockItemQuantity

Definicja kolumny PatientID tabeli StockItemQuantity

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole okresla ruch magazynowy zasobu


Kolumna Comments tabeli StockItemQuantity

Definicja kolumny Comments tabeli StockItemQuantity

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz


Kolumna StockItemQuantityDetailsID tabeli StockItemQuantity

Definicja kolumny StockItemQuantityDetailsID tabeli StockItemQuantity

Name

StockItemQuantityDetailsID

Code

StockItemQuantityDetailsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli StockItemQuantity

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockItemQuantity

Definicja klucza Identifier_1 tabeli StockItemQuantity

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment